Pandas Profiling Report

Dataset statistics

Number of variables	25
Number of observations	10000
Missing cells	311
Missing cells (%)	0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.9 MiB
Average record size in memory	200.0 B

Variable types

Numeric	14
DateTime	2
Categorical	9

Warnings

`AVERAGE_ACCT_AGE` has a high cardinality: 112 distinct values	High cardinality
`CREDIT_HISTORY_LENGTH` has a high cardinality: 192 distinct values	High cardinality
`DISBURSED_AMOUNT` is highly correlated with `ASSET_COST`	High correlation
`ASSET_COST` is highly correlated with `DISBURSED_AMOUNT`	High correlation
`AADHAR_FLAG` is highly correlated with `VOTERID_FLAG`	High correlation
`VOTERID_FLAG` is highly correlated with `AADHAR_FLAG`	High correlation
`DISBURSED_AMOUNT` is highly correlated with `ASSET_COST`	High correlation
`ASSET_COST` is highly correlated with `DISBURSED_AMOUNT`	High correlation
`AADHAR_FLAG` is highly correlated with `VOTERID_FLAG`	High correlation
`VOTERID_FLAG` is highly correlated with `AADHAR_FLAG`	High correlation
`df_index` is highly correlated with `AADHAR_FLAG` and 7 other fields	High correlation
`DISBURSED_AMOUNT` is highly correlated with `ASSET_COST` and 8 other fields	High correlation
`ASSET_COST` is highly correlated with `DISBURSED_AMOUNT` and 8 other fields	High correlation
`LTV` is highly correlated with `AADHAR_FLAG` and 7 other fields	High correlation
`BRANCH_ID` is highly correlated with `AADHAR_FLAG` and 7 other fields	High correlation
`SUPPLIER_ID` is highly correlated with `AADHAR_FLAG` and 7 other fields	High correlation
`MANUFACTURER_ID` is highly correlated with `AADHAR_FLAG` and 7 other fields	High correlation
`CURRENT_PINCODE_ID` is highly correlated with `AADHAR_FLAG` and 6 other fields	High correlation
`STATE_ID` is highly correlated with `AADHAR_FLAG` and 7 other fields	High correlation
`EMPLOYEE_CODE_ID` is highly correlated with `AADHAR_FLAG` and 7 other fields	High correlation
`AADHAR_FLAG` is highly correlated with `df_index` and 16 other fields	High correlation
`PAN_FLAG` is highly correlated with `df_index` and 16 other fields	High correlation
`VOTERID_FLAG` is highly correlated with `df_index` and 16 other fields	High correlation
`PASSPORT_FLAG` is highly correlated with `df_index` and 16 other fields	High correlation
`PERFORM_CNS_SCORE` is highly correlated with `PRI_OVERDUE_ACCTS` and 2 other fields	High correlation
`PRI_OVERDUE_ACCTS` is highly correlated with `df_index` and 16 other fields	High correlation
`NEW_ACCTS_IN_LAST_SIX_MONTHS` is highly correlated with `df_index` and 16 other fields	High correlation
`NO_OF_INQUIRIES` is highly correlated with `df_index` and 16 other fields	High correlation
`LOAN_DEFAULT` is highly correlated with `df_index` and 14 other fields	High correlation
`BRANCH_ID` is highly correlated with `CURRENT_PINCODE_ID` and 1 other fields	High correlation
`CURRENT_PINCODE_ID` is highly correlated with `BRANCH_ID` and 1 other fields	High correlation
`LOAN_DEFAULT` is highly correlated with `EMPLOYMENT_TYPE` and 1 other fields	High correlation
`EMPLOYMENT_TYPE` is highly correlated with `LOAN_DEFAULT`	High correlation
`AADHAR_FLAG` is highly correlated with `VOTERID_FLAG` and 1 other fields	High correlation
`DISBURSED_AMOUNT` is highly correlated with `LTV` and 2 other fields	High correlation
`LTV` is highly correlated with `DISBURSED_AMOUNT`	High correlation
`MANUFACTURER_ID` is highly correlated with `DISBURSED_AMOUNT` and 1 other fields	High correlation
`ASSET_COST` is highly correlated with `DISBURSED_AMOUNT` and 1 other fields	High correlation
`PERFORM_CNS_SCORE_DESCRIPTION` is highly correlated with `PERFORM_CNS_SCORE`	High correlation
`PERFORM_CNS_SCORE` is highly correlated with `LOAN_DEFAULT` and 1 other fields	High correlation
`VOTERID_FLAG` is highly correlated with `AADHAR_FLAG` and 1 other fields	High correlation
`STATE_ID` is highly correlated with `BRANCH_ID` and 3 other fields	High correlation
`AADHAR_FLAG` is highly correlated with `VOTERID_FLAG`	High correlation
`VOTERID_FLAG` is highly correlated with `AADHAR_FLAG`	High correlation
`EMPLOYMENT_TYPE` has 311 (3.1%) missing values	Missing
`df_index` has unique values	Unique
`PERFORM_CNS_SCORE` has 4911 (49.1%) zeros	Zeros
`PRI_OVERDUE_ACCTS` has 8846 (88.5%) zeros	Zeros
`NEW_ACCTS_IN_LAST_SIX_MONTHS` has 7755 (77.5%) zeros	Zeros
`NO_OF_INQUIRIES` has 8673 (86.7%) zeros	Zeros

Reproduction

Analysis started	2021-08-02 18:56:16.288063
Analysis finished	2021-08-02 18:56:52.555009
Duration	36.27 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67635.9967

Minimum	4
Maximum	133146
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	4
5-th percentile	7296.55
Q1	34280.25
median	68325.5
Q3	101181
95-th percentile	126785.15
Maximum	133146
Range	133142
Interquartile range (IQR)	66900.75

Descriptive statistics

Standard deviation	38516.74744
Coefficient of variation (CV)	0.5694711296
Kurtosis	-1.207124721
Mean	67635.9967
Median Absolute Deviation (MAD)	33552
Skewness	-0.02718809912
Sum	676359967
Variance	1483539833
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41225	1	< 0.1%
111514	1	< 0.1%
39229	1	< 0.1%
35083	1	< 0.1%
66190	1	< 0.1%
39292	1	< 0.1%
123557	1	< 0.1%
82022	1	< 0.1%
75635	1	< 0.1%
96055	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1	< 0.1%
7	1	< 0.1%
9	1	< 0.1%
17	1	< 0.1%
29	1	< 0.1%
43	1	< 0.1%
50	1	< 0.1%
55	1	< 0.1%
60	1	< 0.1%
61	1	< 0.1%

Value	Count	Frequency (%)
133146	1	< 0.1%
133138	1	< 0.1%
133118	1	< 0.1%
133095	1	< 0.1%
133085	1	< 0.1%
133043	1	< 0.1%
133036	1	< 0.1%
133015	1	< 0.1%
133003	1	< 0.1%
133002	1	< 0.1%

DISBURSED_AMOUNT
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3410
Distinct (%)	34.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54557.3842

Minimum	13664
Maximum	191392
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	13664
5-th percentile	35139
Q1	47349
median	53908
Q3	60613.25
95-th percentile	74251
Maximum	191392
Range	177728
Interquartile range (IQR)	13264.25

Descriptive statistics

Standard deviation	12546.24397
Coefficient of variation (CV)	0.2299641773
Kurtosis	4.63831939
Mean	54557.3842
Median Absolute Deviation (MAD)	6559
Skewness	0.9504849324
Sum	545573842
Variance	157408237.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53303	99	1.0%
52303	99	1.0%
48349	98	1.0%
47349	94	0.9%
50303	89	0.9%
51303	87	0.9%
56259	83	0.8%
55259	77	0.8%
46349	74	0.7%
57259	68	0.7%
Other values (3400)	9132	91.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
13664	1	< 0.1%
14164	1	< 0.1%
14455	1	< 0.1%
15156	1	< 0.1%
15540	1	< 0.1%
15910	1	< 0.1%
16700	1	< 0.1%
17060	1	< 0.1%
17119	1	< 0.1%
18040	1	< 0.1%

Value	Count	Frequency (%)
191392	1	< 0.1%
167018	1	< 0.1%
134265	1	< 0.1%
131509	1	< 0.1%
129485	1	< 0.1%
127328	1	< 0.1%
127103	1	< 0.1%
120706	3	< 0.1%
120312	1	< 0.1%
119807	1	< 0.1%

ASSET_COST
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7311
Distinct (%)	73.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76110.3872

Minimum	38055
Maximum	255315
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	38055
5-th percentile	58684.55
Q1	65774
median	71066
Q3	79693
95-th percentile	109874.2
Maximum	255315
Range	217260
Interquartile range (IQR)	13919

Descriptive statistics

Standard deviation	18376.77053
Coefficient of variation (CV)	0.2414489165
Kurtosis	9.95686984
Mean	76110.3872
Median Absolute Deviation (MAD)	6466
Skewness	2.462493213
Sum	761103872
Variance	337705695
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
68000	30	0.3%
69000	23	0.2%
73000	22	0.2%
78000	22	0.2%
75000	21	0.2%
66000	20	0.2%
72000	20	0.2%
62188	20	0.2%
77000	19	0.2%
71000	19	0.2%
Other values (7301)	9784	97.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
38055	1	< 0.1%
39459	1	< 0.1%
39620	1	< 0.1%
40167	1	< 0.1%
40668	1	< 0.1%
40680	1	< 0.1%
40768	2	< 0.1%
40986	1	< 0.1%
41000	1	< 0.1%
41064	1	< 0.1%

Value	Count	Frequency (%)
255315	1	< 0.1%
254177	1	< 0.1%
251767	1	< 0.1%
241134	1	< 0.1%
199951	1	< 0.1%
199371	1	< 0.1%
196451	1	< 0.1%
189130	1	< 0.1%
183545	1	< 0.1%
182719	2	< 0.1%

LTV
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	3533
Distinct (%)	35.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	74.76375

Minimum	19.3
Maximum	95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	19.3
5-th percentile	52.48
Q1	68.85
median	76.715
Q3	83.555
95-th percentile	89.35
Maximum	95
Range	75.7
Interquartile range (IQR)	14.705

Descriptive statistics

Standard deviation	11.3507564
Coefficient of variation (CV)	0.1518216569
Kurtosis	1.343324659
Mean	74.76375
Median Absolute Deviation (MAD)	7.215
Skewness	-1.068962027
Sum	747637.5
Variance	128.8396709
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85	167	1.7%
84.99	45	0.4%
79.99	26	0.3%
79.92	21	0.2%
75	19	0.2%
89.96	19	0.2%
80	19	0.2%
74.93	18	0.2%
79.79	18	0.2%
74.91	17	0.2%
Other values (3523)	9631	96.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19.3	1	< 0.1%
21.12	1	< 0.1%
21.64	1	< 0.1%
22.34	1	< 0.1%
22.4	1	< 0.1%
22.45	1	< 0.1%
22.83	1	< 0.1%
24.5	1	< 0.1%
25.35	1	< 0.1%
25.42	1	< 0.1%

Value	Count	Frequency (%)
95	1	< 0.1%
94.99	1	< 0.1%
94.98	1	< 0.1%
94.94	2	< 0.1%
94.92	1	< 0.1%
94.9	1	< 0.1%
94.86	1	< 0.1%
94.85	1	< 0.1%
94.83	1	< 0.1%
94.78	1	< 0.1%

BRANCH_ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	82
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71.2591

Minimum	1
Maximum	261
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	13
median	61
Q3	121
95-th percentile	248
Maximum	261
Range	260
Interquartile range (IQR)	108

Descriptive statistics

Standard deviation	69.39148712
Coefficient of variation (CV)	0.9737912368
Kurtosis	0.3631914529
Mean	71.2591
Median Absolute Deviation (MAD)	50
Skewness	1.054904565
Sum	712591
Variance	4815.178485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	590	5.9%
67	456	4.6%
5	405	4.0%
3	389	3.9%
36	384	3.8%
34	361	3.6%
136	345	3.5%
1	302	3.0%
16	295	2.9%
19	250	2.5%
Other values (72)	6223	62.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	302	3.0%
2	590	5.9%
3	389	3.9%
5	405	4.0%
7	144	1.4%
8	145	1.5%
9	103	1.0%
10	178	1.8%
11	181	1.8%
13	132	1.3%

Value	Count	Frequency (%)
261	7	0.1%
260	18	0.2%
259	18	0.2%
258	9	0.1%
257	44	0.4%
255	61	0.6%
254	72	0.7%
251	166	1.7%
250	54	0.5%
249	43	0.4%

SUPPLIER_ID
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1968
Distinct (%)	19.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19683.0378

Minimum	10524
Maximum	24789
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	10524
5-th percentile	14197.55
Q1	16565
median	20470
Q3	23000
95-th percentile	24151.1
Maximum	24789
Range	14265
Interquartile range (IQR)	6435

Descriptive statistics

Standard deviation	3484.60368
Coefficient of variation (CV)	0.1770358679
Kurtosis	-1.459941397
Mean	19683.0378
Median Absolute Deviation (MAD)	2981
Skewness	-0.1911875221
Sum	196830378
Variance	12142462.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15694	63	0.6%
18317	62	0.6%
15663	61	0.6%
14234	57	0.6%
18166	54	0.5%
21124	53	0.5%
17980	52	0.5%
14375	49	0.5%
14347	47	0.5%
14115	46	0.5%
Other values (1958)	9456	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10524	1	< 0.1%
12312	2	< 0.1%
12374	5	0.1%
12441	2	< 0.1%
12456	7	0.1%
12500	2	< 0.1%
12534	2	< 0.1%
12797	2	< 0.1%
12842	2	< 0.1%
12878	1	< 0.1%

Value	Count	Frequency (%)
24789	1	< 0.1%
24760	1	< 0.1%
24754	1	< 0.1%
24753	1	< 0.1%
24745	2	< 0.1%
24732	4	< 0.1%
24729	1	< 0.1%
24728	1	< 0.1%
24719	2	< 0.1%
24716	1	< 0.1%

MANUFACTURER_ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.3938

Minimum	45
Maximum	145
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	45
5-th percentile	45
Q1	48
median	86
Q3	86
95-th percentile	86
Maximum	145
Range	100
Interquartile range (IQR)	38

Descriptive statistics

Standard deviation	22.17749097
Coefficient of variation (CV)	0.3195889398
Kurtosis	-0.6923296466
Mean	69.3938
Median Absolute Deviation (MAD)	34
Skewness	0.3737814211
Sum	693938
Variance	491.8411057
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
86	4768	47.7%
45	2374	23.7%
51	1157	11.6%
48	715	7.1%
49	421	4.2%
120	419	4.2%
67	107	1.1%
145	39	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
45	2374	23.7%
48	715	7.1%
49	421	4.2%
51	1157	11.6%
67	107	1.1%
86	4768	47.7%
120	419	4.2%
145	39	0.4%

Value	Count	Frequency (%)
145	39	0.4%
120	419	4.2%
86	4768	47.7%
67	107	1.1%
51	1157	11.6%
49	421	4.2%
48	715	7.1%
45	2374	23.7%

CURRENT_PINCODE_ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	3149
Distinct (%)	31.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3415.9663

Minimum	1
Maximum	7345
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	272
Q1	1515
median	2989
Q3	5666
95-th percentile	6944
Maximum	7345
Range	7344
Interquartile range (IQR)	4151

Descriptive statistics

Standard deviation	2233.76098
Coefficient of variation (CV)	0.6539177452
Kurtosis	-1.283278229
Mean	3415.9663
Median Absolute Deviation (MAD)	1931.5
Skewness	0.2637899003
Sum	34159663
Variance	4989688.118
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2578	81	0.8%
1446	71	0.7%
1515	51	0.5%
2989	39	0.4%
2943	39	0.4%
2782	37	0.4%
3000	34	0.3%
1794	33	0.3%
1511	30	0.3%
2378	29	0.3%
Other values (3139)	9556	95.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	< 0.1%
4	2	< 0.1%
5	10	0.1%
6	7	0.1%
7	10	0.1%
9	2	< 0.1%
12	2	< 0.1%
13	3	< 0.1%
14	6	0.1%

Value	Count	Frequency (%)
7345	1	< 0.1%
7336	1	< 0.1%
7333	1	< 0.1%
7325	2	< 0.1%
7324	1	< 0.1%
7322	2	< 0.1%
7321	4	< 0.1%
7313	1	< 0.1%
7308	1	< 0.1%
7306	1	< 0.1%

DATE_OF_BIRTH
Date

Distinct	5317
Distinct (%)	53.2%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Minimum	1954-07-17 00:00:00
Maximum	2000-09-21 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

EMPLOYMENT_TYPE
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	311
Missing (%)	3.1%
Memory size	78.2 KiB

Self employed	5523
Salaried	4166

Length

Max length	13
Median length	13
Mean length	10.85013933
Min length	8

Characters and Unicode

Total characters	105127
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Salaried
2nd row	Salaried
3rd row	Self employed
4th row	Self employed
5th row	Self employed

Common Values

Value	Count	Frequency (%)
Self employed	5523	55.2%
Salaried	4166	41.7%
(Missing)	311	3.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
self	5523	36.3%
employed	5523	36.3%
salaried	4166	27.4%

Most occurring characters

Value	Count	Frequency (%)
e	20735	19.7%
l	15212	14.5%
S	9689	9.2%
d	9689	9.2%
a	8332	7.9%
f	5523	5.3%
	5523	5.3%
m	5523	5.3%
p	5523	5.3%
o	5523	5.3%
Other values (3)	13855	13.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	89915	85.5%
Uppercase Letter	9689	9.2%
Space Separator	5523	5.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	20735	23.1%
l	15212	16.9%
d	9689	10.8%
a	8332	9.3%
f	5523	6.1%
m	5523	6.1%
p	5523	6.1%
o	5523	6.1%
y	5523	6.1%
r	4166	4.6%

Uppercase Letter

Value	Count	Frequency (%)
S	9689	100.0%

Space Separator

Value	Count	Frequency (%)
	5523	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	99604	94.7%
Common	5523	5.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	20735	20.8%
l	15212	15.3%
S	9689	9.7%
d	9689	9.7%
a	8332	8.4%
f	5523	5.5%
m	5523	5.5%
p	5523	5.5%
o	5523	5.5%
y	5523	5.5%
Other values (2)	8332	8.4%

Common

Value	Count	Frequency (%)
	5523	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	105127	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	20735	19.7%
l	15212	14.5%
S	9689	9.2%
d	9689	9.2%
a	8332	7.9%
f	5523	5.3%
	5523	5.3%
m	5523	5.3%
p	5523	5.3%
o	5523	5.3%
Other values (3)	13855	13.2%

DISBURSAL_DATE
Date

Distinct	84
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Minimum	2018-08-01 00:00:00
Maximum	2018-10-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

STATE_ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	22
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.2583

Minimum	1
Maximum	22
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	6
Q3	10
95-th percentile	16
Maximum	22
Range	21
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.456340091
Coefficient of variation (CV)	0.613964715
Kurtosis	-0.3567451897
Mean	7.2583
Median Absolute Deviation (MAD)	3
Skewness	0.8061249074
Sum	72583
Variance	19.85896701
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
4	1946	19.5%
3	1494	14.9%
6	1373	13.7%
13	776	7.8%
9	718	7.2%
8	625	6.2%
14	414	4.1%
5	406	4.1%
1	380	3.8%
7	313	3.1%
Other values (12)	1555	15.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	380	3.8%
2	160	1.6%
3	1494	14.9%
4	1946	19.5%
5	406	4.1%
6	1373	13.7%
7	313	3.1%
8	625	6.2%
9	718	7.2%
10	144	1.4%

Value	Count	Frequency (%)
22	5	0.1%
21	1	< 0.1%
20	4	< 0.1%
19	42	0.4%
18	234	2.3%
17	160	1.6%
16	108	1.1%
15	212	2.1%
14	414	4.1%
13	776	7.8%

EMPLOYEE_CODE_ID
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2629
Distinct (%)	26.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1548.3745

Minimum	1
Maximum	3783
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	152.95
Q1	707
median	1441.5
Q3	2369
95-th percentile	3188.05
Maximum	3783
Range	3782
Interquartile range (IQR)	1662

Descriptive statistics

Standard deviation	978.2866477
Coefficient of variation (CV)	0.6318152667
Kurtosis	-1.062187128
Mean	1548.3745
Median Absolute Deviation (MAD)	816.5
Skewness	0.2470667032
Sum	15483745
Variance	957044.7651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2546	30	0.3%
620	27	0.3%
255	20	0.2%
130	20	0.2%
184	17	0.2%
908	17	0.2%
3132	17	0.2%
2153	17	0.2%
237	16	0.2%
751	16	0.2%
Other values (2619)	9803	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	0.1%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%
7	8	0.1%
9	2	< 0.1%
10	2	< 0.1%
11	2	< 0.1%
12	5	0.1%
15	3	< 0.1%

Value	Count	Frequency (%)
3783	1	< 0.1%
3775	1	< 0.1%
3768	1	< 0.1%
3761	1	< 0.1%
3759	1	< 0.1%
3757	1	< 0.1%
3748	1	< 0.1%
3744	1	< 0.1%
3736	1	< 0.1%
3724	1	< 0.1%

AADHAR_FLAG
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

1	8397
0	1603

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	8397	84.0%
0	1603	16.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	8397	84.0%
0	1603	16.0%

Most occurring characters

Value	Count	Frequency (%)
1	8397	84.0%
0	1603	16.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	8397	84.0%
0	1603	16.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	8397	84.0%
0	1603	16.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	8397	84.0%
0	1603	16.0%

PAN_FLAG
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	9241
1	759

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	9241	92.4%
1	759	7.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	9241	92.4%
1	759	7.6%

Most occurring characters

Value	Count	Frequency (%)
0	9241	92.4%
1	759	7.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	9241	92.4%
1	759	7.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	9241	92.4%
1	759	7.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	9241	92.4%
1	759	7.6%

VOTERID_FLAG
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	8531
1	1469

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	8531	85.3%
1	1469	14.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	8531	85.3%
1	1469	14.7%

Most occurring characters

Value	Count	Frequency (%)
0	8531	85.3%
1	1469	14.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	8531	85.3%
1	1469	14.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	8531	85.3%
1	1469	14.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	8531	85.3%
1	1469	14.7%

PASSPORT_FLAG
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	9970
1	30

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	9970	99.7%
1	30	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	9970	99.7%
1	30	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	9970	99.7%
1	30	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	9970	99.7%
1	30	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	9970	99.7%
1	30	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	9970	99.7%
1	30	0.3%

PERFORM_CNS_SCORE
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	485
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	295.1243

Minimum	0
Maximum	890
Zeros	4911
Zeros (%)	49.1%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	15
Q3	680
95-th percentile	825
Maximum	890
Range	890
Interquartile range (IQR)	680

Descriptive statistics

Standard deviation	339.4487016
Coefficient of variation (CV)	1.150188926
Kurtosis	-1.658707342
Mean	295.1243
Median Absolute Deviation (MAD)	15
Skewness	0.4151665359
Sum	2951243
Variance	115225.421
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4911	49.1%
300	385	3.9%
738	352	3.5%
825	339	3.4%
17	170	1.7%
15	158	1.6%
763	134	1.3%
16	131	1.3%
708	88	0.9%
737	82	0.8%
Other values (475)	3250	32.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4911	49.1%
14	38	0.4%
15	158	1.6%
16	131	1.3%
17	170	1.7%
18	74	0.7%
300	385	3.9%
301	1	< 0.1%
302	1	< 0.1%
305	3	< 0.1%

Value	Count	Frequency (%)
890	1	< 0.1%
879	5	0.1%
858	1	< 0.1%
853	2	< 0.1%
852	1	< 0.1%
850	1	< 0.1%
849	1	< 0.1%
845	26	0.3%
844	3	< 0.1%
839	4	< 0.1%

PERFORM_CNS_SCORE_DESCRIPTION
Categorical

HIGH CORRELATION

Distinct	19
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

No Bureau History Available	4911
C-Very Low Risk	688
A-Very Low Risk	632
D-Very Low Risk	513
B-Very Low Risk	405
Other values (14)	2851

Length

Max length	55
Median length	27
Mean length	22.1557
Min length	10

Characters and Unicode

Total characters	221557
Distinct characters	48
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Bureau History Available
2nd row	No Bureau History Available
3rd row	No Bureau History Available
4th row	No Bureau History Available
5th row	E-Low Risk

Common Values

Value	Count	Frequency (%)
No Bureau History Available	4911	49.1%
C-Very Low Risk	688	6.9%
A-Very Low Risk	632	6.3%
D-Very Low Risk	513	5.1%
B-Very Low Risk	405	4.0%
M-Very High Risk	385	3.9%
K-High Risk	377	3.8%
F-Low Risk	371	3.7%
H-Medium Risk	286	2.9%
E-Low Risk	254	2.5%
Other values (9)	1178	11.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
available	5313	14.8%
no	5116	14.3%
history	5069	14.1%
bureau	4911	13.7%
risk	4518	12.6%
low	2238	6.2%
not	899	2.5%
c-very	688	1.9%
a-very	632	1.8%
scored	571	1.6%
Other values (29)	5902	16.5%

Most occurring characters

Value	Count	Frequency (%)
	25857	11.7%
i	17180	7.8%
a	16174	7.3%
o	15730	7.1%
e	15202	6.9%
r	13592	6.1%
u	11005	5.0%
l	10738	4.8%
s	10241	4.6%
y	7902	3.6%
Other values (38)	77936	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	151438	68.4%
Uppercase Letter	38763	17.5%
Space Separator	25857	11.7%
Dash Punctuation	4518	2.0%
Other Punctuation	571	0.3%
Decimal Number	148	0.1%
Open Punctuation	131	0.1%
Close Punctuation	131	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	17180	11.3%
a	16174	10.7%
o	15730	10.4%
e	15202	10.0%
r	13592	9.0%
u	11005	7.3%
l	10738	7.1%
s	10241	6.8%
y	7902	5.2%
t	7381	4.9%
Other values (12)	26293	17.4%

Uppercase Letter

Value	Count	Frequency (%)
H	6336	16.3%
N	6015	15.5%
A	5832	15.0%
B	5316	13.7%
R	4518	11.7%
L	3062	7.9%
V	2664	6.9%
M	901	2.3%
S	729	1.9%
C	688	1.8%
Other values (9)	2702	7.0%

Decimal Number

Value	Count	Frequency (%)
3	74	50.0%
6	74	50.0%

Space Separator

Value	Count	Frequency (%)
	25857	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4518	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	571	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	131	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	131	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	190201	85.8%
Common	31356	14.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	17180	9.0%
a	16174	8.5%
o	15730	8.3%
e	15202	8.0%
r	13592	7.1%
u	11005	5.8%
l	10738	5.6%
s	10241	5.4%
y	7902	4.2%
t	7381	3.9%
Other values (31)	65056	34.2%

Common

Value	Count	Frequency (%)
	25857	82.5%
-	4518	14.4%
:	571	1.8%
(	131	0.4%
)	131	0.4%
3	74	0.2%
6	74	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	221557	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	25857	11.7%
i	17180	7.8%
a	16174	7.3%
o	15730	7.1%
e	15202	6.9%
r	13592	6.1%
u	11005	5.0%
l	10738	4.8%
s	10241	4.6%
y	7902	3.6%
Other values (38)	77936	35.2%

PRI_OVERDUE_ACCTS
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1586

Minimum	0
Maximum	12
Zeros	8846
Zeros (%)	88.5%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	12
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5428402229
Coefficient of variation (CV)	3.422700018
Kurtosis	84.73015225
Mean	0.1586
Median Absolute Deviation (MAD)	0
Skewness	6.742497825
Sum	1586
Variance	0.2946755076
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	8846	88.5%
1	877	8.8%
2	199	2.0%
3	50	0.5%
4	12	0.1%
5	6	0.1%
7	3	< 0.1%
6	2	< 0.1%
12	2	< 0.1%
9	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8846	88.5%
1	877	8.8%
2	199	2.0%
3	50	0.5%
4	12	0.1%
5	6	0.1%
6	2	< 0.1%
7	3	< 0.1%
8	1	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
12	2	< 0.1%
9	2	< 0.1%
8	1	< 0.1%
7	3	< 0.1%
6	2	< 0.1%
5	6	0.1%
4	12	0.1%
3	50	0.5%
2	199	2.0%
1	877	8.8%

NEW_ACCTS_IN_LAST_SIX_MONTHS
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.39

Minimum	0
Maximum	19
Zeros	7755
Zeros (%)	77.5%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9605166626
Coefficient of variation (CV)	2.462863238
Kurtosis	38.3000325
Mean	0.39
Median Absolute Deviation (MAD)	0
Skewness	4.563673903
Sum	3900
Variance	0.9225922592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	7755	77.5%
1	1365	13.7%
2	508	5.1%
3	189	1.9%
4	92	0.9%
5	36	0.4%
6	27	0.3%
7	13	0.1%
8	6	0.1%
9	4	< 0.1%
Other values (4)	5	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7755	77.5%
1	1365	13.7%
2	508	5.1%
3	189	1.9%
4	92	0.9%
5	36	0.4%
6	27	0.3%
7	13	0.1%
8	6	0.1%
9	4	< 0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
16	1	< 0.1%
11	2	< 0.1%
10	1	< 0.1%
9	4	< 0.1%
8	6	0.1%
7	13	0.1%
6	27	0.3%
5	36	0.4%
4	92	0.9%

AVERAGE_ACCT_AGE
Categorical

HIGH CARDINALITY

Distinct	112
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0yrs 0mon	5034
0yrs 6mon	249
0yrs 9mon	237
0yrs 7mon	223
0yrs 8mon	222
Other values (107)	4035

Length

Max length	11
Median length	9
Mean length	9.0742
Min length	9

Characters and Unicode

Total characters	90742
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.2%

Sample

1st row	0yrs 0mon
2nd row	0yrs 0mon
3rd row	0yrs 0mon
4th row	0yrs 0mon
5th row	1yrs 7mon

Common Values

Value	Count	Frequency (%)
0yrs 0mon	5034	50.3%
0yrs 6mon	249	2.5%
0yrs 9mon	237	2.4%
0yrs 7mon	223	2.2%
0yrs 8mon	222	2.2%
0yrs 10mon	218	2.2%
1yrs 0mon	213	2.1%
0yrs 11mon	210	2.1%
0yrs 5mon	207	2.1%
1yrs 1mon	190	1.9%
Other values (102)	2997	30.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0yrs	7153	35.8%
0mon	5414	27.1%
1yrs	1600	8.0%
2yrs	664	3.3%
6mon	467	2.3%
5mon	438	2.2%
2mon	435	2.2%
4mon	433	2.2%
1mon	425	2.1%
7mon	420	2.1%
Other values (17)	2551	12.8%

Most occurring characters

Value	Count	Frequency (%)
0	12958	14.3%
y	10000	11.0%
r	10000	11.0%
s	10000	11.0%
	10000	11.0%
m	10000	11.0%
o	10000	11.0%
n	10000	11.0%
1	3113	3.4%
2	1102	1.2%
Other values (7)	3569	3.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	60000	66.1%
Decimal Number	20742	22.9%
Space Separator	10000	11.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	12958	62.5%
1	3113	15.0%
2	1102	5.3%
3	716	3.5%
4	566	2.7%
5	508	2.4%
6	508	2.4%
7	437	2.1%
8	427	2.1%
9	407	2.0%

Lowercase Letter

Value	Count	Frequency (%)
y	10000	16.7%
r	10000	16.7%
s	10000	16.7%
m	10000	16.7%
o	10000	16.7%
n	10000	16.7%

Space Separator

Value	Count	Frequency (%)
	10000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	60000	66.1%
Common	30742	33.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	12958	42.2%
	10000	32.5%
1	3113	10.1%
2	1102	3.6%
3	716	2.3%
4	566	1.8%
5	508	1.7%
6	508	1.7%
7	437	1.4%
8	427	1.4%

Latin

Value	Count	Frequency (%)
y	10000	16.7%
r	10000	16.7%
s	10000	16.7%
m	10000	16.7%
o	10000	16.7%
n	10000	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90742	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	12958	14.3%
y	10000	11.0%
r	10000	11.0%
s	10000	11.0%
	10000	11.0%
m	10000	11.0%
o	10000	11.0%
n	10000	11.0%
1	3113	3.4%
2	1102	1.2%
Other values (7)	3569	3.9%

CREDIT_HISTORY_LENGTH
Categorical

HIGH CARDINALITY

Distinct	192
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0yrs 0mon	5016
0yrs 6mon	227
2yrs 1mon	187
2yrs 0mon	173
0yrs 7mon	171
Other values (187)	4226

Length

Max length	11
Median length	9
Mean length	9.0914
Min length	9

Characters and Unicode

Total characters	90914
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30 ?
Unique (%)	0.3%

Sample

1st row	0yrs 0mon
2nd row	0yrs 0mon
3rd row	0yrs 0mon
4th row	0yrs 0mon
5th row	3yrs 3mon

Common Values

Value	Count	Frequency (%)
0yrs 0mon	5016	50.2%
0yrs 6mon	227	2.3%
2yrs 1mon	187	1.9%
2yrs 0mon	173	1.7%
0yrs 7mon	171	1.7%
1yrs 0mon	138	1.4%
0yrs 11mon	125	1.2%
1yrs 1mon	120	1.2%
0yrs 9mon	115	1.1%
1yrs 6mon	103	1.0%
Other values (182)	3625	36.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0yrs	6283	31.4%
0mon	5536	27.7%
1yrs	1129	5.6%
2yrs	969	4.8%
1mon	540	2.7%
3yrs	535	2.7%
6mon	509	2.5%
7mon	440	2.2%
2mon	434	2.2%
3mon	412	2.1%
Other values (24)	3213	16.1%

Most occurring characters

Value	Count	Frequency (%)
0	12202	13.4%
y	10000	11.0%
r	10000	11.0%
s	10000	11.0%
	10000	11.0%
m	10000	11.0%
o	10000	11.0%
n	10000	11.0%
1	3015	3.3%
2	1439	1.6%
Other values (7)	4258	4.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	60000	66.0%
Decimal Number	20914	23.0%
Space Separator	10000	11.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	12202	58.3%
1	3015	14.4%
2	1439	6.9%
3	978	4.7%
4	714	3.4%
6	649	3.1%
5	598	2.9%
7	511	2.4%
9	409	2.0%
8	399	1.9%

Lowercase Letter

Value	Count	Frequency (%)
y	10000	16.7%
r	10000	16.7%
s	10000	16.7%
m	10000	16.7%
o	10000	16.7%
n	10000	16.7%

Space Separator

Value	Count	Frequency (%)
	10000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	60000	66.0%
Common	30914	34.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	12202	39.5%
	10000	32.3%
1	3015	9.8%
2	1439	4.7%
3	978	3.2%
4	714	2.3%
6	649	2.1%
5	598	1.9%
7	511	1.7%
9	409	1.3%

Latin

Value	Count	Frequency (%)
y	10000	16.7%
r	10000	16.7%
s	10000	16.7%
m	10000	16.7%
o	10000	16.7%
n	10000	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90914	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	12202	13.4%
y	10000	11.0%
r	10000	11.0%
s	10000	11.0%
	10000	11.0%
m	10000	11.0%
o	10000	11.0%
n	10000	11.0%
1	3015	3.3%
2	1439	1.6%
Other values (7)	4258	4.7%

NO_OF_INQUIRIES
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2075

Minimum	0
Maximum	18
Zeros	8673
Zeros (%)	86.7%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	18
Range	18
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7250491843
Coefficient of variation (CV)	3.494212936
Kurtosis	109.0026748
Mean	0.2075
Median Absolute Deviation (MAD)	0
Skewness	7.801653559
Sum	2075
Variance	0.5256963196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	8673	86.7%
1	951	9.5%
2	224	2.2%
3	72	0.7%
4	34	0.3%
5	18	0.2%
7	11	0.1%
9	5	0.1%
6	5	0.1%
8	3	< 0.1%
Other values (4)	4	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8673	86.7%
1	951	9.5%
2	224	2.2%
3	72	0.7%
4	34	0.3%
5	18	0.2%
6	5	0.1%
7	11	0.1%
8	3	< 0.1%
9	5	0.1%

Value	Count	Frequency (%)
18	1	< 0.1%
17	1	< 0.1%
13	1	< 0.1%
10	1	< 0.1%
9	5	0.1%
8	3	< 0.1%
7	11	0.1%
6	5	0.1%
5	18	0.2%
4	34	0.3%

LOAN_DEFAULT
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	6650
1	3350

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	6650	66.5%
1	3350	33.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	6650	66.5%
1	3350	33.5%

Most occurring characters

Value	Count	Frequency (%)
0	6650	66.5%
1	3350	33.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6650	66.5%
1	3350	33.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6650	66.5%
1	3350	33.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6650	66.5%
1	3350	33.5%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	DISBURSED_AMOUNT	ASSET_COST	LTV	BRANCH_ID	SUPPLIER_ID	MANUFACTURER_ID	CURRENT_PINCODE_ID	DATE_OF_BIRTH	EMPLOYMENT_TYPE	DISBURSAL_DATE	STATE_ID	EMPLOYEE_CODE_ID	AADHAR_FLAG	PERFORM_CNS_SCORE	PERFORM_CNS_SCORE_DESCRIPTION	PRI_OVERDUE_ACCTS	NEW_ACCTS_IN_LAST_SIX_MONTHS	AVERAGE_ACCT_AGE	CREDIT_HISTORY_LENGTH	LOAN_DEFAULT
0	41225	40394	76660	54.79	1	18080	45	5083	1974-01-01	Salaried	2018-10-12	3	1616	1	0	No Bureau History Available	0	0	0yrs 0mon	0yrs 0mon	0
1	27185	39439	65390	61.17	105	15792	45	1218	1971-01-01	Salaried	2018-10-13	6	937	1	0	No Bureau History Available	0	0	0yrs 0mon	0yrs 0mon	0
2	61563	48849	77200	64.77	10	22742	86	5662	1991-02-27	Self employed	2018-08-29	3	1746	1	0	No Bureau History Available	0	0	0yrs 0mon	0yrs 0mon	1
3	7402	47049	82086	59.33	1	22315	86	5092	1997-01-01	Self employed	2018-10-25	3	136	1	0	No Bureau History Available	0	0	0yrs 0mon	0yrs 0mon	1
4	1000	56007	67351	85.00	5	15663	86	3373	1984-03-01	Self employed	2018-09-03	9	963	1	686	E-Low Risk	1	0	1yrs 7mon	3yrs 3mon	0
5	84578	71117	92000	78.80	76	17242	48	4467	1994-06-22	Self employed	2018-09-20	8	220	1	0	No Bureau History Available	0	0	0yrs 0mon	0yrs 0mon	1
6	87655	53963	68429	81.84	16	18150	45	2943	1981-05-21	Self employed	2018-09-17	17	2346	1	17	Not Scored: Not Enough Info available on the customer	0	0	0yrs 5mon	0yrs 5mon	1
7	119045	57559	71151	83.62	16	18317	86	2959	1987-02-15	Salaried	2018-09-20	14	2075	1	640	G-Low Risk	0	0	1yrs 5mon	2yrs 4mon	0
8	34691	49763	73616	70.64	142	17315	86	109	1994-10-08	Salaried	2018-08-24	16	331	1	525	J-High Risk	1	3	0yrs 10mon	2yrs 6mon	0
9	28616	61647	94610	68.70	11	23399	48	5633	1980-03-05	Self employed	2018-08-20	3	1395	1	0	No Bureau History Available	0	0	0yrs 0mon	0yrs 0mon	0

Last rows

	df_index	DISBURSED_AMOUNT	ASSET_COST	LTV	BRANCH_ID	SUPPLIER_ID	MANUFACTURER_ID	CURRENT_PINCODE_ID	DATE_OF_BIRTH	EMPLOYMENT_TYPE	DISBURSAL_DATE	STATE_ID	EMPLOYEE_CODE_ID	AADHAR_FLAG	PAN_FLAG	VOTERID_FLAG	PERFORM_CNS_SCORE	PERFORM_CNS_SCORE_DESCRIPTION	NEW_ACCTS_IN_LAST_SIX_MONTHS	AVERAGE_ACCT_AGE	CREDIT_HISTORY_LENGTH	NO_OF_INQUIRIES	LOAN_DEFAULT
9990	57953	50703	63470	81.93	67	18166	86	1511	1983-03-29	Salaried	2018-08-21	6	949	1	0	0	738	C-Very Low Risk	2	0yrs 4mon	0yrs 4mon	0	0
9991	61098	44998	69998	65.21	65	23246	49	6808	1971-01-14	Salaried	2018-10-24	13	199	1	0	0	738	C-Very Low Risk	1	1yrs 0mon	1yrs 7mon	1	0
9992	12920	49803	67302	76.52	16	22004	45	2976	1974-05-12	Salaried	2018-08-29	14	194	1	0	0	635	G-Low Risk	0	4yrs 0mon	8yrs 5mon	0	0
9993	82518	55959	69884	85.86	138	17175	45	3329	1982-06-01	Self employed	2018-10-05	9	2174	1	0	0	719	D-Very Low Risk	1	1yrs 3mon	3yrs 2mon	1	0
9994	85209	52135	70250	75.70	138	17408	51	3349	1976-06-24	Self employed	2018-10-29	9	2690	1	0	0	763	B-Very Low Risk	0	1yrs 3mon	3yrs 1mon	1	0
9995	71686	63913	122354	53.12	36	24622	48	6560	1990-01-01	Salaried	2018-10-25	13	724	0	0	1	0	No Bureau History Available	0	0yrs 0mon	0yrs 0mon	0	0
9996	81522	48578	67716	74.58	74	23424	51	2615	1970-01-01	Self employed	2018-09-26	4	3159	1	0	1	0	No Bureau History Available	0	0yrs 0mon	0yrs 0mon	0	0
9997	31944	66882	87000	78.16	2	24040	120	1732	1985-01-01	Salaried	2018-09-18	4	2655	1	0	0	737	C-Very Low Risk	0	0yrs 11mon	0yrs 11mon	0	0
9998	67406	51328	77250	68.93	254	23292	51	6757	1977-06-12	Self employed	2018-10-03	13	859	0	1	1	17	Not Scored: Not Enough Info available on the customer	0	4yrs 2mon	4yrs 2mon	0	1
9999	83835	54513	64921	86.26	61	21911	86	1369	1975-06-01	Self employed	2018-08-17	6	1655	1	0	0	763	B-Very Low Risk	0	0yrs 11mon	0yrs 11mon	0	0

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation